# coding=utf-8
import xlrd
data = xlrd.open_workbook('data.xlsx')
table = data.sheet_by_index(0) #通过索引顺序获取

writer = open('data.csv', 'w') # 若是'wb'就表示写二进制文件
str = ''
for row in range(table.nrows):
    for col in range(table.ncols):
        if row == 0 or col <= 1:
            continue

        if col < table.ncols-1:
            str = '%s,' % (table.cell(row, col).value)
        else:
            str = '%s' % (table.cell(row, col).value)
        writer.write(str)
    if str != '':
        writer.write('\n')
writer.close()